import openpyxl
wb = openpyxl.load_workbook('/Users/zhangxiangbin/招商局资本管理有限责任公司_I017-2022-01-2022-06_2022年1-6月计提账单.xlsx')

# You can loop through worksheets
for ws in wb:
    print(ws.title)

# You can review the names of all worksheets of the workbook with the Workbook.sheetname attribute
print(wb.sheetnames)

# Once you gave a worksheet a name, you can get it as a key of the workbook
ws1 = wb['汇总']
# print(ws1.title)


